/**
 * BillTableMetaData.java
 * com.jamin.aabill.db
 *
 * Function： TODO 
 *
 *   ver     date      		author
 * ──────────────────────────────────
 *   		 2012-9-3 		wangjieming
 *
 * Copyright (c) 2012, TNT All Rights Reserved.
 */

package com.jamin.aabill.db;

import android.provider.BaseColumns;

/**
 * ClassName:BillTableMetaData
 *
 * @author   wangjieming
 * @version  1.0
 * @since    v1.0
 * @Date	 2012-9-3 下午9:02:13 
 */
public class BillTableMetaData implements BaseColumns {


	public static final String TABLE_NAME = "bill";
	public static final String CIRCLE_ID  = "circle_id";
	public static final String CREATOR_MEMBER_ID = "creator_member_id";
	public static final String PROJECT  = "project";
	public static final String TYPE  = "type";
	public static final String DESCRIPTION  = "description";
	public static final String MODIFY_AT  = "modify_at";
	public static final String CREATE_AT  = "create_at";



	public static final String CREATE_TABLE_SQL =  "CREATE TABLE IF NOT EXISTS "
			+ TABLE_NAME + "(" 
			+ _ID+ " INTEGER PRIMARY KEY," 
			+ CIRCLE_ID + " INTEGER," 
			+ CREATOR_MEMBER_ID + " INTEGER," 
			+ PROJECT + " TEXT,"
			+ TYPE + " INTEGER,"
			+ DESCRIPTION + " INTEGER," 
			+ MODIFY_AT + " INTEGER,"
			+ CREATE_AT + " INTEGER" 
			+ ");";



	public static final String DROP_TABLE_SQL = "DROP TABLE IF EXISTS "+ TABLE_NAME;


}

